LOAD DATA
TRUNCATE 
INTO TABLE cafou_bde_tppm_tb
FIELDS TERMINATED BY X'09'
TRAILING NULLCOLS 
(
 LINE_NO		RECNUM
,DATE_PROD   		Date 	"YYYY-MM-DD"                                      
,CD_PORTEFEUILLE	"TRIM(BOTH FROM :CD_PORTEFEUILLE)"                                                    
,CD_DIVISION      	"TRIM(BOTH FROM :CD_DIVISION)"                                                   
,CD_DIRECTION     	"TRIM(BOTH FROM :CD_DIRECTION)"                                                   
,CD_ACTIVITE     	"TRIM(BOTH FROM :CD_ACTIVITE)"                                                   
,CD_MODE_GESTION      	"TRIM(BOTH FROM :CD_MODE_GESTION)"                                                    
,CD_CL_ACTIF      	"TRIM(BOTH FROM :CD_CL_ACTIF)"                                                                   
,ID_TITRE
,CD_TITRE		"TRIM(BOTH FROM :CD_TITRE)"                                                   
,MNT_PP
,PROVENANCE		"TRIM(BOTH FROM :PROVENANCE)"
,ID_CAISSE_TITRE	
)                                                                                                      
